﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using CarFrameWork.Common;
namespace CarFrameWork.Model.CanShuHua
{
    /// <summary>
    /// 类主齿凸缘螺母。
    /// </summary>
    [Serializable]
    public partial class 主齿凸缘螺母
    {
        public 主齿凸缘螺母()
        { }
        #region Model
        private int _id;
        private string _name;
        private string _path;
        private float _d1;
        private float _d2;
        private float _d3;
        private float _d4;
        private float _d5;
        private float _d6;
        private float _h;
        private float _h1;
        private float _h4;
        private float _r4;
        private float _t;
        /// <summary>
        /// 
        /// </summary>
        public int ID
        {
            set { _id = value; }
            get { return _id; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string name
        {
            set { _name = value; }
            get { return _name; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string path
        {
            set { _path = value; }
            get { return _path; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float D1
        {
            set { _d1 = value; }
            get { return _d1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float D2
        {
            set { _d2 = value; }
            get { return _d2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float D3
        {
            set { _d3 = value; }
            get { return _d3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float D4
        {
            set { _d4 = value; }
            get { return _d4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float D5
        {
            set { _d5 = value; }
            get { return _d5; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float D6
        {
            set { _d6 = value; }
            get { return _d6; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float H
        {
            set { _h = value; }
            get { return _h; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float H1
        {
            set { _h1 = value; }
            get { return _h1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float H4
        {
            set { _h4 = value; }
            get { return _h4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float R4
        {
            set { _r4 = value; }
            get { return _r4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float T
        {
            set { _t = value; }
            get { return _t; }
        }
        #endregion Model


        #region  Method

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public 主齿凸缘螺母(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ID,name,path,D1,D2,D3,D4,D5,D6,H,H1,H4,R4,T ");
            strSql.Append(" FROM [主齿凸缘螺母] ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
                {
                    this.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["name"] != null && ds.Tables[0].Rows[0]["name"].ToString() != "")
                {
                    this.name = ds.Tables[0].Rows[0]["name"].ToString();
                }
                if (ds.Tables[0].Rows[0]["path"] != null && ds.Tables[0].Rows[0]["path"].ToString() != "")
                {
                    this.path = ds.Tables[0].Rows[0]["path"].ToString();
                }
                if (ds.Tables[0].Rows[0]["D1"] != null && ds.Tables[0].Rows[0]["D1"].ToString() != "")
                {
                    this.D1 = float.Parse(ds.Tables[0].Rows[0]["D1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D2"] != null && ds.Tables[0].Rows[0]["D2"].ToString() != "")
                {
                    this.D2 = float.Parse(ds.Tables[0].Rows[0]["D2"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D3"] != null && ds.Tables[0].Rows[0]["D3"].ToString() != "")
                {
                    this.D3 = float.Parse(ds.Tables[0].Rows[0]["D3"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D4"] != null && ds.Tables[0].Rows[0]["D4"].ToString() != "")
                {
                    this.D4 = float.Parse(ds.Tables[0].Rows[0]["D4"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D5"] != null && ds.Tables[0].Rows[0]["D5"].ToString() != "")
                {
                    this.D5 = float.Parse(ds.Tables[0].Rows[0]["D5"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D6"] != null && ds.Tables[0].Rows[0]["D6"].ToString() != "")
                {
                    this.D6 = float.Parse(ds.Tables[0].Rows[0]["D6"].ToString());
                }
                if (ds.Tables[0].Rows[0]["H"] != null && ds.Tables[0].Rows[0]["H"].ToString() != "")
                {
                    this.H = float.Parse(ds.Tables[0].Rows[0]["H"].ToString());
                }
                if (ds.Tables[0].Rows[0]["H1"] != null && ds.Tables[0].Rows[0]["H1"].ToString() != "")
                {
                    this.H1 = float.Parse(ds.Tables[0].Rows[0]["H1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["H4"] != null && ds.Tables[0].Rows[0]["H4"].ToString() != "")
                {
                    this.H4 = float.Parse(ds.Tables[0].Rows[0]["H4"].ToString());
                }
                if (ds.Tables[0].Rows[0]["R4"] != null && ds.Tables[0].Rows[0]["R4"].ToString() != "")
                {
                    this.R4 = float.Parse(ds.Tables[0].Rows[0]["R4"].ToString());
                }
                if (ds.Tables[0].Rows[0]["T"] != null && ds.Tables[0].Rows[0]["T"].ToString() != "")
                {
                    this.T = float.Parse(ds.Tables[0].Rows[0]["T"].ToString());
                }
            }
        }

        /// <summary>
        /// 得到最大ID
        /// </summary>
        public int GetMaxId()
        {

            return DbHelperSQL.GetMaxID("ID", "主齿凸缘螺母");
        }

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from [主齿凸缘螺母]");
            strSql.Append(" where ID=@ID ");

            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into [主齿凸缘螺母] (");
            strSql.Append("name,path,D1,D2,D3,D4,D5,D6,H,H1,H4,R4,T)");
            strSql.Append(" values (");
            strSql.Append("@name,@path,@D1,@D2,@D3,@D4,@D5,@D6,@H,@H1,@H4,@R4,@T)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@name", SqlDbType.NVarChar,50),
					new SqlParameter("@path", SqlDbType.NVarChar),
					new SqlParameter("@D1", SqlDbType.Float,8),
					new SqlParameter("@D2", SqlDbType.Float,8),
					new SqlParameter("@D3", SqlDbType.Float,8),
					new SqlParameter("@D4", SqlDbType.Float,8),
					new SqlParameter("@D5", SqlDbType.Float,8),
					new SqlParameter("@D6", SqlDbType.Float,8),
					new SqlParameter("@H", SqlDbType.Float,8),
					new SqlParameter("@H1", SqlDbType.Float,8),
					new SqlParameter("@H4", SqlDbType.Float,8),
					new SqlParameter("@R4", SqlDbType.Float,8),
					new SqlParameter("@T", SqlDbType.Float,8)};
            parameters[0].Value = name;
            parameters[1].Value = path;
            parameters[2].Value = D1;
            parameters[3].Value = D2;
            parameters[4].Value = D3;
            parameters[5].Value = D4;
            parameters[6].Value = D5;
            parameters[7].Value = D6;
            parameters[8].Value = H;
            parameters[9].Value = H1;
            parameters[10].Value = H4;
            parameters[11].Value = R4;
            parameters[12].Value = T;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update [主齿凸缘螺母] set ");
            strSql.Append("name=@name,");
            strSql.Append("path=@path,");
            strSql.Append("D1=@D1,");
            strSql.Append("D2=@D2,");
            strSql.Append("D3=@D3,");
            strSql.Append("D4=@D4,");
            strSql.Append("D5=@D5,");
            strSql.Append("D6=@D6,");
            strSql.Append("H=@H,");
            strSql.Append("H1=@H1,");
            strSql.Append("H4=@H4,");
            strSql.Append("R4=@R4,");
            strSql.Append("T=@T");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@name", SqlDbType.NVarChar,50),
					new SqlParameter("@path", SqlDbType.NVarChar),
					new SqlParameter("@D1", SqlDbType.Float,8),
					new SqlParameter("@D2", SqlDbType.Float,8),
					new SqlParameter("@D3", SqlDbType.Float,8),
					new SqlParameter("@D4", SqlDbType.Float,8),
					new SqlParameter("@D5", SqlDbType.Float,8),
					new SqlParameter("@D6", SqlDbType.Float,8),
					new SqlParameter("@H", SqlDbType.Float,8),
					new SqlParameter("@H1", SqlDbType.Float,8),
					new SqlParameter("@H4", SqlDbType.Float,8),
					new SqlParameter("@R4", SqlDbType.Float,8),
					new SqlParameter("@T", SqlDbType.Float,8),
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = name;
            parameters[1].Value = path;
            parameters[2].Value = D1;
            parameters[3].Value = D2;
            parameters[4].Value = D3;
            parameters[5].Value = D4;
            parameters[6].Value = D5;
            parameters[7].Value = D6;
            parameters[8].Value = H;
            parameters[9].Value = H1;
            parameters[10].Value = H4;
            parameters[11].Value = R4;
            parameters[12].Value = T;
            parameters[13].Value = ID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from [主齿凸缘螺母] ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public void GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ID,name,path,D1,D2,D3,D4,D5,D6,H,H1,H4,R4,T ");
            strSql.Append(" FROM [主齿凸缘螺母] ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
                {
                    this.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["name"] != null && ds.Tables[0].Rows[0]["name"].ToString() != "")
                {
                    this.name = ds.Tables[0].Rows[0]["name"].ToString();
                }
                if (ds.Tables[0].Rows[0]["path"] != null && ds.Tables[0].Rows[0]["path"].ToString() != "")
                {
                    this.path = ds.Tables[0].Rows[0]["path"].ToString();
                }
                if (ds.Tables[0].Rows[0]["D1"] != null && ds.Tables[0].Rows[0]["D1"].ToString() != "")
                {
                    this.D1 = float.Parse(ds.Tables[0].Rows[0]["D1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D2"] != null && ds.Tables[0].Rows[0]["D2"].ToString() != "")
                {
                    this.D2 = float.Parse(ds.Tables[0].Rows[0]["D2"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D3"] != null && ds.Tables[0].Rows[0]["D3"].ToString() != "")
                {
                    this.D3 = float.Parse(ds.Tables[0].Rows[0]["D3"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D4"] != null && ds.Tables[0].Rows[0]["D4"].ToString() != "")
                {
                    this.D4 = float.Parse(ds.Tables[0].Rows[0]["D4"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D5"] != null && ds.Tables[0].Rows[0]["D5"].ToString() != "")
                {
                    this.D5 = float.Parse(ds.Tables[0].Rows[0]["D5"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D6"] != null && ds.Tables[0].Rows[0]["D6"].ToString() != "")
                {
                    this.D6 = float.Parse(ds.Tables[0].Rows[0]["D6"].ToString());
                }
                if (ds.Tables[0].Rows[0]["H"] != null && ds.Tables[0].Rows[0]["H"].ToString() != "")
                {
                    this.H = float.Parse(ds.Tables[0].Rows[0]["H"].ToString());
                }
                if (ds.Tables[0].Rows[0]["H1"] != null && ds.Tables[0].Rows[0]["H1"].ToString() != "")
                {
                    this.H1 = float.Parse(ds.Tables[0].Rows[0]["H1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["H4"] != null && ds.Tables[0].Rows[0]["H4"].ToString() != "")
                {
                    this.H4 = float.Parse(ds.Tables[0].Rows[0]["H4"].ToString());
                }
                if (ds.Tables[0].Rows[0]["R4"] != null && ds.Tables[0].Rows[0]["R4"].ToString() != "")
                {
                    this.R4 = float.Parse(ds.Tables[0].Rows[0]["R4"].ToString());
                }
                if (ds.Tables[0].Rows[0]["T"] != null && ds.Tables[0].Rows[0]["T"].ToString() != "")
                {
                    this.T = float.Parse(ds.Tables[0].Rows[0]["T"].ToString());
                }
            }
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [主齿凸缘螺母] ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        #endregion  Method
    }
}

